How to: Create a select query using a Query Wizard.
Solution:
Click the 'Queries' tab in the Database window, click 'New', select 'Simple Query Wizard' from the list box, click 'OK', and follow the instructions in the 'Simple Query Wizard' dialog boxes.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Click 'New'. (The New Query dialog box appears.)
4) Select the 'Simple Query Wizard' from the list box.
Select wizard
NOTE: There are four query wizards: 'Simple Query Wizard', 'Crosstab Query Wizard', 'Find Duplicates Query Wizard', and 'Find UnMatched Query Wizard'.
5) Click 'OK'. (The 'Simple Query Wizard' dialog box appears.)
6) Select the table or query containing the fields to be in the select query from the 'Tables/Queries' drop-down list box.
Tables/Queries
7) Select the desired field to include in the select query from the 'Available Fields' list box.
Available fields
8) Click '>'. (The selected field appears in the Selected Fields list box.)
GREATER THAN button
9) Repeat steps 7) and 8) for each field to be used in the select query from the table or query selected in step 6).
10) Repeat steps 6) through 9) for each table or query containing field or fields to include in the select query.
11) Click 'Next'.
12) (Special Case) If a screen appears asking whether to display a detail or a summary query:
a) Do one of the following:
Select radio button
1] To create a query containing all details from every record, select the 'Detail (shows every field of every record)' radio button.
2] To create a summary query:
a] Select the 'Summary' radio button.
b] Click 'Summary Options...'. (The Summary Options dialog box appears.)
c] Select the desired check boxes for which summary values to calculate for each field listed.
Select values
d] (Optional) Select the 'Count records in <table or query>' check box, where <table or query> is the name of one of the tables or queries used.
e] Click 'OK'. (The Simple Query Wizard dialog box reappears.)
b) Click 'Next'.
13) (Special Case) If a date field was selected as one of the fields to include in the query, do the following:
a) Select a radio button for how to group the dates.
b) Click 'Next'.
14) Type a name for the query in the 'What title do you want for your query?' box.
Query title
15) Select the desired radio button for whether to run the query or to modify the query design.
Select radio button
16) Click 'Finish'. (The query appears in either Datasheet view or Design view, depending on the radio button selected in step 15).)
